#统计<各省份平均分sheet>中各省份的平均分(数据合并)
import pandas as pd

df0 = pd.read_excel('D:\ITAudit\pandas_excel\pc\Stu_new_1score_list.xlsx',sheet_name='各省份平均分')
df1 = pd.read_excel('D:\ITAudit\pandas_excel\pc\Stu_new_2score_list.xlsx',sheet_name='各省份平均分')
df2 = pd.read_excel('D:\ITAudit\pandas_excel\pc\Stu_new_3score_list.xlsx',sheet_name='各省份平均分')
# print(df)
province_average_score = []
province_average_score.append(df0)
province_average_score.append(df1)
province_average_score.append(df2)
df = pd.concat(province_average_score,axis=1)
print(df)